ContentValidation Properties

Properties

AllowEmptyCell Specifies whether a cell can be empty. The default value for this attribute is true.
BaseCellAddress Contains the address of the base cell for relative addresses in formulas that occur within a condition. This attribute is only necessary when the condition contains a formula. The value of this attribute shall be an absolute cell address that contains a table name.
Condition Contains the condition that determines whether a cell content is valid in regard to a validation rule or not.
DisplayListType Specifies whether a list of values that occurs within a condition is displayed in the UI wile entering a cell value.
ErrorMessage Contains the message to display if a user tries to enter invalid content into a cell. That is when a validation rule's condition evaluates to “false” on the content the user attempts to enter.
HelpMessage Contains the message to display if a user selects a cell.
Name Contains the name of a content validation rule. It is used to reference the validation rule from the cell the rule should applied.

See Also